Ledger Summary by GL Code Report

The Ledger Summary by GL Code Report displays the grand total of the charges posted and the payments made for each transaction item in the property, in the ascending order of the GL code associated with the items, for the selected date range.

Perform the following steps to generate the report:

Navigate to Reports ➜ Dynamic Reports ➜ Accounting ➜ Ledger Summary by GL Code.

Refer to the following table and fill in the fields.

Field	Description
Report Name	Ledger Summary by GL Code.
Property	This is a mandatory field that displays the current property by default. Users can select the preferred properties for which the report must be generated.
Start Date	The start date from which the report must be generated. Users can select any date in the past up to the current property date. Future dates cannot be selected.
End Date	The end date up to which the report must be generated. Users can select any date in the past that is greater than the start date, up to the current property date. Future dates cannot be selected.

Click Run to generate the report.

Click Save to save the report under User Favorites section.

Sample Report

Report Fields

This report displays the following fields:

Field	Description
Property	Displays the records grouped by the selected properties with an accordion. By default, the accordion is expanded and displays the values for the report columns. When collapsed, the total of the charges and payments made for the items associated with the GL code is displayed.
GL Code	Displays the items in the ascending order of the GL code under each property. If two or more properties have the same GL code attached, the GL codes and their revenues are calculated and displayed under the respective properties. If two or more items under the property have the same GL code attached, the items and their revenues are calculated and displayed in the alphabetical order of their type/item name. The items without GL code are displayed in the alphabetical order of their type/item name under each property and the GL Code column is left blank. Users can search, sort, and filter records using this column.
Type	Displays the name of the item associated with the GL code. Users can search, sort, and filter records using this column.
Payments	Displays the payments, deposits, and refunds made under the GL code for the selected date range.
Charges	Displays the charges posted for every item under the GL code for the selected date range.